DATE_FORMAT

                    $data = Item::select("id","title","created_at")
                    ->where(DB::raw("(DATE_FORMAT(created_at,'%Y-%m'))"),"2022-07")
                    ->get();
                    

whereDate

                    $products = Product::select("*")
                        ->whereDate('created_at', '2023-09-03')
                        ->get();

whereMonth

$products = Product::select("*")
                        ->whereMonth('created_at', '09')
                        ->get();

whereDay

$products = Product::select("*")
                        ->whereDay('created_at', '03')
                        ->get();

whereYear

$products = Product::select("*")
                        ->whereYear('created_at', '2023')
                        ->get();